123456/PO PHP H5/Julian - Felix/slachtoffers.php

<!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" href="style/style.css"> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <html><h1>Slachtoffers</h1></html> <table border="1"> <tr> <th>slachtofferID</th> <th>voornaam</th> <th>achternaam</th> <th>geboorte datum</th> <th>woon plaats</th> </tr> <?php include('db.php'); $query = "select * from slachtoffer"; $result = mysqli_query($db, $query); while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>$row[slachtofferID]</td>"; echo "<td><a href='slachtoffer_gegevens.php?slachtofferID=" . $row['slachtofferID'] . "'>$row[voornaam_slachtoffer]</td>"; echo "<td><a href='slachtoffer_gegevens.php?slachtofferID=" . $row['slachtofferID'] . "'>$row[achternaam_slachtoffer]</td>"; echo "<td>$row[geb_datum]</td>"; echo "<td>$row[woon_plaats]</td>"; echo "</tr>"; } ?> </body> <button onclick="location.href='gevangenis.php'">gevangenissen</button> <button onclick="location.href='moorden.php'">moorden</button> <button onclick="location.href='moordenaars.php'">moordenaars</button> <button onclick="location.href='index.php'">homepagina</button> </html>

Resultaat

Made by Thijs Aarnoudse